DBA Data[Home] [Help]

APPS.AHL_OSP_SHIPMENT_PUB dependencies on CSI_T_TXN_LINE_DETAILS

Line 2402: csi_t_txn_line_details tld,

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)
2406: OR NVL(oe_return_line_id, -9) = NVL(p_line_id, -8))

Line 6419: csi_t_txn_line_details tld,

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
6423: AND tl.source_transaction_table = G_TRANSACTION_TABLE

Line 6660: csi_t_txn_line_details tld,

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
6664: AND tl.transaction_line_id = tld.transaction_line_id