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.

APPS.WMS_LPN_LOVS dependencies on RCV_SHIPMENT_HEADERS

Line 2798: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,

2794: lpn.source_header_id,
2795: rsh.shipment_num,
2796: count_row.n,
2797: rsh.shipment_header_id
2798: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
2799: (SELECT COUNT(*) n
2800: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh
2801: --WHERE lpn.license_plate_number LIKE (p_lpn)--Bug 3090000
2802: WHERE lpn.lpn_context IN (6, 7) -- context for vendor LPN

Line 2800: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh

2796: count_row.n,
2797: rsh.shipment_header_id
2798: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
2799: (SELECT COUNT(*) n
2800: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh
2801: --WHERE lpn.license_plate_number LIKE (p_lpn)--Bug 3090000
2802: WHERE lpn.lpn_context IN (6, 7) -- context for vendor LPN
2803: AND rsh.shipment_header_id = Nvl(To_number(p_shipment_header_id), rsh.shipment_header_id)
2804: AND (lpn.source_header_id = rsh.shipment_header_id

Line 2843: FROM wms_license_plate_numbers wlpn1, rcv_shipment_headers rsh

2839: wlpn1.source_header_id,
2840: rsh.shipment_num,
2841: 1,--This is a dummy value. Actually cound will be calculated in validate_from_lpn
2842: rsh.shipment_header_id
2843: FROM wms_license_plate_numbers wlpn1, rcv_shipment_headers rsh
2844: WHERE rsh.shipment_header_id = p_shipment_header_id
2845: AND ((wlpn1.lpn_context = 6 AND wlpn1.organization_id = rsh.organization_id) OR
2846: (wlpn1.lpn_context = 7 AND wlpn1.organization_id = rsh.ship_to_org_id))
2847: AND wlpn1.source_name = rsh.shipment_num

Line 2888: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,

2884: lpn.source_header_id,
2885: rsh.shipment_num,
2886: count_row.n,
2887: rsh.shipment_header_id
2888: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
2889: (SELECT COUNT(*) n
2890: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh
2891: --WHERE lpn.license_plate_number LIKE (p_lpn) --Bug 3090000
2892: WHERE lpn.lpn_context IN (6, 7) -- context for vendor LPN

Line 2890: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh

2886: count_row.n,
2887: rsh.shipment_header_id
2888: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
2889: (SELECT COUNT(*) n
2890: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh
2891: --WHERE lpn.license_plate_number LIKE (p_lpn) --Bug 3090000
2892: WHERE lpn.lpn_context IN (6, 7) -- context for vendor LPN
2893: --AND rsh.shipment_header_id = Nvl(To_number(p_shipment_header_id), rsh.shipment_header_id)
2894: AND (lpn.source_header_id = rsh.shipment_header_id

Line 2935: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,

2931: lpn.source_header_id,
2932: rsh.shipment_num,
2933: count_row.n,
2934: rsh.shipment_header_id
2935: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
2936: ( SELECT COUNT(*) n
2937: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh
2938: --WHERE lpn.license_plate_number LIKE (p_lpn) --Bug 3090000
2939: WHERE lpn.lpn_context IN (6, 7) -- context for vendor LPN

Line 2937: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh

2933: count_row.n,
2934: rsh.shipment_header_id
2935: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
2936: ( SELECT COUNT(*) n
2937: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh
2938: --WHERE lpn.license_plate_number LIKE (p_lpn) --Bug 3090000
2939: WHERE lpn.lpn_context IN (6, 7) -- context for vendor LPN
2940: AND rsh.shipment_header_id = p_shipment_header_id
2941: AND (lpn.source_header_id = rsh.shipment_header_id

Line 2974: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,

2970: lpn.source_header_id,
2971: rsh.shipment_num,
2972: count_row.n,
2973: rsh.shipment_header_id
2974: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
2975: ( SELECT COUNT(*) n
2976: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh
2977: --WHERE lpn.license_plate_number LIKE (p_lpn) --Bug 3090000
2978: WHERE lpn.lpn_context IN (6, 7) -- context for vendor LPN

Line 2976: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh

2972: count_row.n,
2973: rsh.shipment_header_id
2974: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
2975: ( SELECT COUNT(*) n
2976: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh
2977: --WHERE lpn.license_plate_number LIKE (p_lpn) --Bug 3090000
2978: WHERE lpn.lpn_context IN (6, 7) -- context for vendor LPN
2979: --AND rsh.shipment_header_id = Nvl(To_number(p_shipment_header_id), rsh.shipment_header_id)
2980: AND (lpn.source_header_id = rsh.shipment_header_id

Line 3015: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,

3011: lpn.source_header_id,
3012: rsh.shipment_num,
3013: count_row.n,
3014: rsh.shipment_header_id
3015: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
3016: ( SELECT COUNT(*) n
3017: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh
3018: --WHERE lpn.license_plate_number LIKE (p_lpn) --Bug 3090000
3019: WHERE lpn.lpn_context IN (6, 7) -- context for vendor LPN

Line 3017: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh

3013: count_row.n,
3014: rsh.shipment_header_id
3015: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
3016: ( SELECT COUNT(*) n
3017: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh
3018: --WHERE lpn.license_plate_number LIKE (p_lpn) --Bug 3090000
3019: WHERE lpn.lpn_context IN (6, 7) -- context for vendor LPN
3020: AND rsh.shipment_header_id = p_shipment_header_id
3021: AND (lpn.source_header_id = rsh.shipment_header_id

Line 3055: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,

3051: lpn.source_header_id,
3052: rsh.shipment_num,
3053: count_row.n,
3054: rsh.shipment_header_id
3055: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
3056: ( SELECT COUNT(*) n
3057: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh
3058: --WHERE lpn.license_plate_number LIKE (p_lpn) --Bug 3090000
3059: WHERE lpn.lpn_context IN (6, 7) -- context for vendor LPN

Line 3057: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh

3053: count_row.n,
3054: rsh.shipment_header_id
3055: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
3056: ( SELECT COUNT(*) n
3057: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh
3058: --WHERE lpn.license_plate_number LIKE (p_lpn) --Bug 3090000
3059: WHERE lpn.lpn_context IN (6, 7) -- context for vendor LPN
3060: --AND rsh.shipment_header_id = Nvl(To_number(p_shipment_header_id), rsh.shipment_header_id)
3061: AND (lpn.source_header_id = rsh.shipment_header_id