eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AHL_OSP_SHIPMENT_PUB dependencies on CSI_T_TXN_LINE_DETAILS

Line 2367: csi_t_txn_line_details tld,

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

Line 6374: csi_t_txn_line_details tld,

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

Line 6615: csi_t_txn_line_details tld,

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