APPS.AHL_OSP_SHIPMENT_PUB dependencies on CSI_T_TRANSACTION_LINES

Line 2366: csi_t_transaction_lines tl,

2362: ospl.inventory_item_uom ,
2363: ospl.inventory_item_quantity
2364: from ahl_osp_order_lines ospl,
2365: oe_order_lines_all oel,
2366: csi_t_transaction_lines tl,
2367: csi_t_txn_line_details tld,
2368: csi_item_instances csi
2369: where ospl.osp_order_id = p_osp_order_id
2370: AND (NVL(oe_ship_line_id, -9) = NVL(p_line_id, -8)

Line 5394: FROM csi_t_transaction_lines

5390: IS
5391:
5392: CURSOR csi_txn_lines_csr (p_oe_line_id IN NUMBER) IS
5393: SELECT transaction_line_id
5394: FROM csi_t_transaction_lines
5395: WHERE SOURCE_TRANSACTION_ID = p_oe_line_id
5396: -- 3/3/03: Corrected to include txn table
5397: AND SOURCE_TRANSACTION_TABLE = G_TRANSACTION_TABLE;
5398:

Line 6373: FROM csi_t_transaction_lines tl,

6369: SELECT csi.instance_id,
6370: csi.inventory_item_id,
6371: csi.serial_number,
6372: csi.last_vld_organization_id
6373: FROM csi_t_transaction_lines tl,
6374: csi_t_txn_line_details tld,
6375: ahl_osp_order_lines ospl,
6376: csi_item_instances csi
6377: WHERE tl.source_transaction_id = ospl.oe_ship_line_id

Line 6614: FROM csi_t_transaction_lines tl,

6610: AND ospl.oe_return_line_id = retl.line_id(+);
6611:
6612: CURSOR get_ship_line_instance(c_osp_order_line_id IN NUMBER) IS
6613: SELECT tld.instance_id
6614: FROM csi_t_transaction_lines tl,
6615: csi_t_txn_line_details tld,
6616: ahl_osp_order_lines ospl
6617: WHERE tl.source_transaction_id = ospl.oe_ship_line_id
6618: AND tl.source_transaction_table = G_TRANSACTION_TABLE