PO采购-采购申请单

2014-01-03

purchasing super user -> requisitions-> requisitions

头信息：

number :  po_requisition_headers_all.segment1

description : po_requisition_headers_all.description

type :

SELECT podt.type_name
  FROM po_requisition_headers_all prh,
       po_document_types_all      podt
 WHERE podt.document_type_code = 'REQUISITION'
   AND podt.document_subtype = prh.type_lookup_code
   AND prh.segment1 = 'SY2011101701－JT01'
   AND prh.org_id = podt.org_id;

status : po_requisition_headers_all.authorization_status

preparer :

SELECT papf.full_name
  FROM po_requisition_headers_all prh,
       per_people_f               papf
 WHERE prh.preparer_id = papf.person_id
   AND papf.employee_number IS NOT NULL
   AND prh.segment1 = 'SY2011101701－JT01';

total : --

 

行信息:

lines tab :  

num : po_requsition_lines_all.line_num

type :

SELECT plt.line_type
  FROM po_requisition_lines_all prl,
       po_line_types            plt
 WHERE plt.line_type_id = prl.line_type_id
   AND prl.requisition_header_id = 176311;

item ：

SELECT msi.segment1 item_num
  FROM po_requisition_lines_all prl,
       mtl_system_items_b       msi
 WHERE msi.inventory_item_id = prl.item_id
   AND msi.organization_id = prl.org_id
   AND prl.requisition_header_id = 176311;

rev : po_requisition_lines_all.item_revision

category :

description : po_requisition_lines_all.item_description

uom : po_requisition_lines_all.unit_meas_lookup_code

quantity : po_requisition_lines_all.quantity

price : po_requisition_lines_all.unit_price

need by : po_requisition_lines_all.need_by_date

tax code :

SELECT atc.name
  FROM po_requisition_lines_all prl,
       ap_tax_codes             atc
 WHERE prl.tax_code_id = atc.tax_id(+)
   AND prl.requisition_header_id = 176311;

amount : --

charge account : --

描述性弹性域：批次号：po_requisition_lines_all.attribute1

                            项目编号：po_requisition_lines_all.attribute2

                            部门编号：po_requisition_lines_all.attribute3

                            运费承担方：po_requisition_lines_all.attribute4

                            发运类型：po_requisition_lines_all.attribute5

                            发运方法：po_requisition_lines_all.attribute6

destination type:  po_requisition_lines_all.destination_context

requester :

SELECT papf2.full_name
  FROM po_requisition_lines_all prl,
       per_all_people_f         papf2
 WHERE papf2.person_id = prl.to_person_id
   AND papf2.employee_number IS NOT NULL
   AND prl.requisition_header_id = 176311;

organization :

SELECT hou2.name
  FROM po_requisition_lines_all prl,
       hr_organization_units    hou2
 WHERE hou2.organization_id = prl.destination_organization_id
   AND prl.requisition_header_id = 176311;

location :

SELECT hrl1.location_code
  FROM po_requisition_lines_all prl,
       hr_locations_all_tl      hrl1
 WHERE hrl1.location_id(+) = prl.deliver_to_location_id
   AND hrl1.language(+) = userenv('LANG')
   AND prl.requisition_header_id = 176311;

subinventory : po_requisition_lines_all.destination_subinventory

source :   (po_requisition_lines_all.source_type_code)

supplier :  po_requisition_lines_all.suggested_vendor_name

site : po_requisition_lines_all.suggested_vendor_location

contact : po_requisition_lines_all.suggested_vendor_contact

phone : po_requisition_lines_all.suggested_vendor_phone

 

source details tab:

note to buyer :  po_requisition_lines_all.note_to_agent

buyer :

SELECT ppf.full_name
  FROM po_requisition_lines_all prl,
       per_people_f             ppf
 WHERE ppf.person_id(+) = prl.suggested_buyer_id
   AND prl.requisition_header_id = 176311;

supplier item : po_requisition_lines_all.suggested_vendor_product_code

document type: po_requsition_lines_all.document_type_code

...

details tab :

...

currency tab :

currency : po_requisition_lines_all.currency_code

rate type : --

rate date : po_requisition_lines_all.rate_date

rate : po_requisition_lines_all.rate

...

 

distributions :

 accounts:

num : po_req_distributions_all.distribution_num

quantity : po_req_distributions_all.req_line_quantity

charge account : --

recovery rate : po_req_distributions_all.recovery_rate

gl date : po_req_distributions_all.gl_encumbered_date

budget account : --

accrual account : --

variance account : --

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

总结

以上是生活随笔为你收集整理的PO采购-采购申请单的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。