APPS.AHL_OSP_SHIPMENT_PUB dependencies on CSI_T_TRANSACTION_LINES

Line 2401: csi_t_transaction_lines tl,

2397: ospl.inventory_item_uom ,
2398: ospl.inventory_item_quantity
2399: from ahl_osp_order_lines ospl,
2400: oe_order_lines_all oel,
2401: csi_t_transaction_lines tl,
2402: csi_t_txn_line_details tld,
2403: csi_item_instances csi
2404: where ospl.osp_order_id = p_osp_order_id
2405: AND (NVL(oe_ship_line_id, -9) = NVL(p_line_id, -8)

Line 5439: FROM csi_t_transaction_lines

5435: IS
5436:
5437: CURSOR csi_txn_lines_csr (p_oe_line_id IN NUMBER) IS
5438: SELECT transaction_line_id
5439: FROM csi_t_transaction_lines
5440: WHERE SOURCE_TRANSACTION_ID = p_oe_line_id
5441: -- 3/3/03: Corrected to include txn table
5442: AND SOURCE_TRANSACTION_TABLE = G_TRANSACTION_TABLE;
5443:

Line 6418: FROM csi_t_transaction_lines tl,

6414: SELECT csi.instance_id,
6415: csi.inventory_item_id,
6416: csi.serial_number,
6417: csi.last_vld_organization_id
6418: FROM csi_t_transaction_lines tl,
6419: csi_t_txn_line_details tld,
6420: ahl_osp_order_lines ospl,
6421: csi_item_instances csi
6422: WHERE tl.source_transaction_id = ospl.oe_ship_line_id

Line 6659: FROM csi_t_transaction_lines tl,

6655: AND ospl.oe_return_line_id = retl.line_id(+);
6656:
6657: CURSOR get_ship_line_instance(c_osp_order_line_id IN NUMBER) IS
6658: SELECT tld.instance_id
6659: FROM csi_t_transaction_lines tl,
6660: csi_t_txn_line_details tld,
6661: ahl_osp_order_lines ospl
6662: WHERE tl.source_transaction_id = ospl.oe_ship_line_id
6663: AND tl.source_transaction_table = G_TRANSACTION_TABLE