DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on PER_PEOPLE_F

Line 137: po_vendor_sites_all pvs, per_people_f ppf

133: -- MOAC : po_line_locations changed to po_line_locations_all
134: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
135: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
136: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
137: po_vendor_sites_all pvs, per_people_f ppf
138: where rti.interface_transaction_id = p_transaction_id
139: AND rti.po_header_id = pha.po_header_id(+)
140: AND rsh.shipment_header_id(+) = rti.shipment_header_id
141: AND pol.po_line_id (+) = rti.po_line_id

Line 169: po_vendor_sites_all pvs, per_people_f ppf

165: -- MOAC : po_line_locations changed to po_line_locations_all
166: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
167: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
168: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
169: po_vendor_sites_all pvs, per_people_f ppf
170: where rti.interface_transaction_id = p_transaction_id
171: AND rti.po_header_id = pha.po_header_id(+)
172: AND rsh.shipment_header_id(+) = rti.shipment_header_id
173: AND pol.po_line_id (+) = rti.po_line_id

Line 368: , per_people_f ppf

364: -- , hr_locations_all hrl1
365: -- , hr_locations_all hrl2
366: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
367: , po_vendor_sites_all pvs
368: , per_people_f ppf
369: , wms_license_plate_numbers wlpn
370: WHERE pha.po_header_id(+) = all_lpn.po_header_id
371: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
372: AND rsh.shipment_header_id = rsl.shipment_header_id

Line 1000: , per_people_f ppf

996: , hr_locations_all hrl1
997: , hr_locations_all hrl2
998: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
999: , po_vendor_sites_all pvs
1000: , per_people_f ppf
1001: WHERE pha.po_header_id(+) = all_lpn.po_header_id
1002: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
1003: AND pol.po_line_id (+) = all_lpn.po_line_id
1004: AND pol.po_header_id (+) = all_lpn.po_header_id

Line 1117: , per_people_f ppf

1113: , mcch.cycle_count_header_name
1114: , ppf.full_name requestor
1115: FROM mtl_cycle_count_headers mcch
1116: , mtl_cycle_count_entries mcce
1117: , per_people_f ppf
1118: WHERE mcce.cycle_count_entry_id = p_transaction_Id
1119: AND ppf.person_id(+) = mcce.counted_by_employee_id_current
1120: AND mcce.cycle_count_header_id=mcch.cycle_count_header_id;
1121:

Line 1129: , per_people_f ppf

1125: SELECT mcch.cycle_count_header_name
1126: , ppf.full_name requestor
1127: FROM mtl_cycle_count_headers mcch
1128: , mtl_cycle_count_entries mcce
1129: , per_people_f ppf
1130: , mtl_material_transactions_temp mmtt
1131: WHERE mmtt.transaction_temp_id= p_transaction_id
1132: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
1133: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id

Line 1197: l_requestor per_people_f.FULL_NAME%TYPE;

1193:
1194: -- Increased this variable size to the corresponding column size in the table.
1195: l_supplier_name po_vendors.VENDOR_NAME%TYPE;
1196: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
1197: l_requestor per_people_f.FULL_NAME%TYPE;
1198: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
1199: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
1200: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
1201: