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 2799: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,

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

Line 2801: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh

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

Line 2844: FROM wms_license_plate_numbers wlpn1, rcv_shipment_headers rsh

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

Line 2889: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,

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

Line 2891: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh

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

Line 2936: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,

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

Line 2938: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh

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

Line 2975: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,

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

Line 2977: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh

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

Line 3016: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,

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

Line 3018: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh

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

Line 3056: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh,

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

Line 3058: FROM wms_license_plate_numbers lpn, rcv_shipment_headers rsh

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