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

??????????????????????????? 運(yùn)費(fèi)承擔(dān)方：po_requisition_lines_all.attribute4

??????????????????????????? 發(fā)運(yùn)類型：po_requisition_lines_all.attribute5

??????????????????????????? 發(fā)運(yùn)方法：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 : --

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

總結(jié)

以上是生活随笔為你收集整理的PO采购-采购申请单的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。