eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on PER_PEOPLE_F

Line 212: po_vendor_sites_all pvs, per_people_f ppf

208: -- MOAC : changed po_line_locations to po_line_locations_all
209: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
210: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
211: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
212: po_vendor_sites_all pvs, per_people_f ppf
213: where rti.interface_transaction_id = p_transaction_id
214: AND rti.po_header_id = pha.po_header_id(+)
215: AND rsh.shipment_header_id(+) = rti.shipment_header_id
216: AND pol.po_line_id(+) = rti.po_line_id --Added outer join, bug 4918726

Line 244: po_vendor_sites_all pvs, per_people_f ppf

240: -- MOAC : changed po_line_locations to po_line_locations_all
241: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
242: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
243: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
244: po_vendor_sites_all pvs, per_people_f ppf
245: where rti.interface_transaction_id = p_transaction_id
246: AND rti.po_header_id = pha.po_header_id(+)
247: AND rsh.shipment_header_id(+) = rti.shipment_header_id
248: AND pol.po_line_id (+) = rti.po_line_id

Line 436: , per_people_f ppf

432: -- , hr_locations_all hrl1
433: -- , hr_locations_all hrl2
434: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
435: , po_vendor_sites_all pvs
436: , per_people_f ppf
437: , wms_license_plate_numbers wlpn -- Bug 3836623
438: WHERE pha.po_header_id(+) = all_lpn.po_header_id
439: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
440: AND rsh.shipment_header_id = rsl.shipment_header_id

Line 713: , per_people_f ppf

709: , hr_locations_all hrl1
710: , hr_locations_all hrl2
711: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
712: , po_vendor_sites_all pvs
713: , per_people_f ppf
714: WHERE pha.po_header_id(+) = all_lpn.po_header_id
715: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
716: AND pol.po_line_id (+) = all_lpn.po_line_id
717: AND pol.po_header_id (+) = all_lpn.po_header_id

Line 1135: , per_people_f ppf

1131: , mcch.cycle_count_header_name
1132: , ppf.full_name requestor
1133: FROM mtl_cycle_count_headers mcch
1134: , mtl_cycle_count_entries mcce
1135: , per_people_f ppf
1136: WHERE mcce.cycle_count_entry_id = p_transaction_Id
1137: AND ppf.person_id(+) = mcce.counted_by_employee_id_current
1138: AND mcce.cycle_count_header_id=mcch.cycle_count_header_id;
1139:

Line 1149: , per_people_f ppf

1145: SELECT mcch.cycle_count_header_name
1146: , ppf.full_name requestor
1147: FROM mtl_cycle_count_headers mcch
1148: , mtl_cycle_count_entries mcce
1149: , per_people_f ppf
1150: , mtl_material_transactions_temp mmtt
1151: WHERE mmtt.transaction_temp_id= p_transaction_id
1152: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
1153: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id

Line 1411: l_requestor per_people_f.FULL_NAME%TYPE;

1407:
1408: -- Increased this variable size to the corresponding column size in the table.
1409: l_supplier_name po_vendors.VENDOR_NAME%TYPE;
1410: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
1411: l_requestor per_people_f.FULL_NAME%TYPE;
1412: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
1413: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
1414: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
1415: