APPS.WMS_DIRECT_SHIP_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 9369: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE

9365: , secondary_quantity wms_lpn_contents.secondary_quantity%TYPE
9366: , revision_control VARCHAR2(5)
9367: , lot_control VARCHAR2(5)
9368: , serial_control VARCHAR2(5)
9369: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE
9370: , reservable_type mtl_system_items_b.reservable_type%TYPE
9371: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
9372: , ont_pricing_qty_source VARCHAR2(30)
9373: );

Line 9370: , reservable_type mtl_system_items_b.reservable_type%TYPE

9366: , revision_control VARCHAR2(5)
9367: , lot_control VARCHAR2(5)
9368: , serial_control VARCHAR2(5)
9369: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE
9370: , reservable_type mtl_system_items_b.reservable_type%TYPE
9371: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
9372: , ont_pricing_qty_source VARCHAR2(30)
9373: );
9374: l_lpn_content_cur_rec l_lpn_content_cur_rec_typ;

Line 9508: ' , mtl_system_items_b msi ' ||

9504: ' , NULL ' ||
9505: ' , msi.ont_pricing_qty_source ' ||
9506: ' FROM wms_lpn_contents wlc ' ||
9507: ' , wms_license_plate_numbers wlpn ' ||
9508: ' , mtl_system_items_b msi ' ||
9509: ' WHERE msi.inventory_item_id = wlc.inventory_item_id ' ||
9510: ' AND wlpn.lpn_id = wlc.parent_lpn_id ' ||
9511: ' AND wlpn.outermost_lpn_id = :p_lpn_id ' ||
9512: ' AND wlpn.organization_id = :p_org_id ' ||

Line 9547: ' , mtl_system_items_b msi ' ||

9543: ' , msn.end_item_unit_number ' ||
9544: ' , msi.ont_pricing_qty_source ' ||
9545: ' FROM wms_lpn_contents wlc ' ||
9546: ' , wms_license_plate_numbers wlpn ' ||
9547: ' , mtl_system_items_b msi ' ||
9548: ' , (SELECT lpn_id ' ||
9549: ' , revision ' ||
9550: ' , lot_number ' ||
9551: ' , inventory_item_id ' ||