DBA Data[Home] [Help]

APPS.GME_LPN_MOBILE_TXN dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 95: FROM wms_license_plate_numbers wlpn,

91: SELECT wlpn.license_plate_number,
92: wlpn.lpn_id,
93: wlc.inventory_item_id,
94: wlc.quantity
95: FROM wms_license_plate_numbers wlpn,
96: wms_lpn_contents wlc
97: WHERE wlpn.lpn_id = wlc.parent_lpn_id (+)
98: AND wlpn.organization_id = wlc.organization_id (+)
99: AND wlpn.organization_id = p_org_id