PO Requisition tables are : Headers information stored in PO_REQUISITION_HEADERS_ALL and lines information store in PO_REQUISITION_LINES_ALL . Other tables are used in PO_DOCUMENT_TYPES_ALL_TL, PER_ALL_PEOPLE_F, PER_ADDRESSES, PO_LINE_TYPES, AP_SUPPLIER_SITES, HR_LOCATIONS, MTL_SYSTEM_ITEM_B.
PO Requisition Tables and Relation in Oracle Apps R12
PO Requisition Tables
Query for PO Requisition Report in R12
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
| SELECT-- prha.segment1 REQ_NUM , podta.type_name "REQUISITION_TYPE" , prha.DESCRIPTION , prha.creation_date , prha.authorization_status , prha.approved_date , (SELECT SUM(prla.quantity*prla.unit_price) FROM po_requisition_lines_all req_line WHERE req_line.requisition_header_id=prha.requisition_header_id) "REQ TOTAL AMMOUNT" , papf.full_name "PREPAREAR ID" , pre_addr.address_line1 "PRE-ADDR1" , pre_addr.town_or_city "PRE CITY" , pre_addr.region_1 "PRE REGION" , pre_addr.country "PRE COUNTRY" , pre_addr.postal_code "PRE ZIP" , prla.line_num , plt.line_type , prla.unit_meas_lookup_code , prla.unit_price , prla.quantity , to_char(prla.NEED_BY_DATE,'DD MON, YYYY ') , papf2.full_name "REQUESTER" , req_addr.region_1 "REQ REGION" , req_addr.town_or_city "REQ CITY" , req_addr.postal_code "REQ ZIP" , req_addr.country "REQ COUNTRY" , prla.suggested_vendor_name "SUPPLIER NAME" , prla.suggested_vendor_location "SUPPLIER SITE" , prla.suggested_vendor_contact "CONTACT NAME" , prla.suggested_vendor_phone "PHONE NUM" , ass.city "SUPPLIER CITY" , ass.state "SUPPLIER STATE" , ass.country "SUPPLIER COUNTY" , ass.zip "SUPLLIER ZIP" , prla.destination_subinventory "SUB INV" , hla.location_code "SHIP TO" , hla.location_code "SHIP SITE" , hla.address_line_1||','||hla.address_line_2||','||hla.address_line_3 "SHIP ADDR" , hla.town_or_city "SHIP CITY" , hla.postal_code "SHIP ZIP" , hla.country "SHIP COUNTRY"--FROM -- po_requisition_headers_all prha , po_document_types_all_tl podta , per_all_people_f papf , per_addresses pre_addr , per_addresses req_addr , po_requisition_lines_all prla , per_all_people_f papf2 , ap_supplier_sites ass , po_line_types plt , mtl_system_items_b msib , hr_locations hla--WHERE -- prha.type_lookup_code=podta.document_subtype AND prha.org_id=podta.org_id AND prha.preparer_id=papf.person_id AND prha.requisition_header_id = prla.requisition_header_id AND prla.line_type_id=plt.line_type_id AND prla.to_person_id=papf2.person_id AND prla.org_id = msib.organization_id AND prla.item_id=msib.inventory_item_id AND pre_addr.person_id=prha.preparer_id AND req_addr.person_id=prla.to_person_id AND ass.vendor_site_id(+)=prla.vendor_site_id AND hla.location_id=prla.deliver_to_location_id AND sysdate between papf.effective_start_date and papf.effective_end_date AND sysdate between papf2.effective_start_date and papf.effective_end_date AND prha.SEGMENT1 BETWEEN :REQ_NUM_FROM AND :REQ_NUM_TO |
0 comments