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.

APPS.CSI_T_UTILITIES_PVT dependencies on OE_ORDER_LINES_ALL

Line 532: l_mo_org_id oe_order_lines_all.org_id%TYPE;

528: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
529: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
530: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
531:
532: l_mo_org_id oe_order_lines_all.org_id%TYPE;
533: l_serial_control_code mtl_system_items_b.serial_number_control_code%TYPE;
534: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
535: l_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;
536: l_loop_count number;

Line 539: l_item_type_code oe_order_lines_all.item_type_code%TYPE;

535: l_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;
536: l_loop_count number;
537: l_td_quantity number;
538: l_uom varchar2(30);
539: l_item_type_code oe_order_lines_all.item_type_code%TYPE;
540: l_location_type_code varchar2(30) := fnd_api.g_miss_char;
541: l_location_id number := fnd_api.g_miss_num;
542: l_operating_unit_id number;
543: l_oa_relationship_code varchar2(30);

Line 560: IF px_txn_line_rec.source_transaction_table = 'OE_ORDER_LINES_ALL' THEN

556: BEGIN
557:
558: x_return_status := fnd_api.g_ret_sts_success;
559:
560: IF px_txn_line_rec.source_transaction_table = 'OE_ORDER_LINES_ALL' THEN
561:
562: BEGIN
563:
564: SELECT ol.inventory_item_id,

Line 592: FROM oe_order_lines_all ol,

588: l_txn_source_rec.ship_to_address_id,
589: l_sold_from_org_id,
590: l_line_id,
591: px_txn_line_rec.source_txn_header_id
592: FROM oe_order_lines_all ol,
593: oe_order_headers_all oh
594: WHERE line_id = px_txn_line_rec.source_transaction_id
595: AND oh.header_id = ol.header_id;
596:

Line 847: l_mo_org_id oe_order_lines_all.org_id%TYPE;

843:
844: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
845: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
846:
847: l_mo_org_id oe_order_lines_all.org_id%TYPE;
848: l_serial_control_code mtl_system_items_b.serial_number_control_code%TYPE;
849: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
850: l_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;
851: l_loop_count number;

Line 1119: FROM oe_order_lines_all

1115: l_om_vld_org_id number;
1116: BEGIN
1117:
1118: SELECT org_id INTO l_org_id
1119: FROM oe_order_lines_all
1120: WHERE line_id = p_order_line_id;
1121:
1122: l_om_vld_org_id := oe_sys_parameters.value(
1123: param_name => 'MASTER_ORGANIZATION_ID',

Line 1261: FROM oe_order_lines_all

1257: --fix for bug5096435
1258: BEGIN
1259: SELECT nvl(model_remnant_flag,'N'),ordered_quantity
1260: INTO l_model_remnant_flag,l_model_qty
1261: FROM oe_order_lines_all
1262: WHERE line_id=l_parent_source_id;
1263: EXCEPTION
1264: WHEN no_data_found THEN
1265: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');

Line 1274: FROM oe_order_lines_all

1270: IF l_model_remnant_flag = 'Y' THEN
1271: BEGIN
1272: SELECT nvl(link_to_line_id,-99)
1273: INTO l_link_to_line_id
1274: FROM oe_order_lines_all
1275: WHERE line_id=l_child_source_id;
1276: EXCEPTION
1277: WHEN no_data_found THEN
1278: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');

Line 1286: FROM oe_order_lines_all

1282: END;
1283: IF l_link_to_line_id <> -99 THEN
1284:
1285: SELECT SUM(ordered_quantity) INTO l_sum_qty
1286: FROM oe_order_lines_all
1287: WHERE link_to_line_id = l_link_to_line_id
1288: AND inventory_item_id = l_inventory_item_id;
1289:
1290: l_quantity_ratio := l_sum_qty/l_model_qty;

Line 1309: l_parent_source_table := 'OE_ORDER_LINES_ALL';

1305: debug(' Ordered Quantity : '|| l_order_qty); --fix for bug5096435
1306: debug(' quantity_ratio : '|| l_quantity_ratio);
1307: debug(' item_uom : '|| l_item_uom);
1308:
1309: l_parent_source_table := 'OE_ORDER_LINES_ALL';
1310:
1311: l_txn_cascade_tbl(1).parent_source_table := l_parent_source_table;
1312: l_txn_cascade_tbl(1).parent_source_id := l_parent_source_id;
1313: l_txn_cascade_tbl(1).child_source_id := l_child_source_id;

Line 1344: l_model_line_rec oe_order_lines_all%rowtype;

1340: x_return_status OUT NOCOPY varchar2)
1341: IS
1342:
1343: l_om_vld_org_id number;
1344: l_model_line_rec oe_order_lines_all%rowtype;
1345: l_line_tbl oe_order_pub.line_tbl_type;
1346: l_qty_ratio number;
1347: l_tc_ind number;
1348: l_txn_cascade_tbl csi_t_utilities_pvt.txn_cascade_tbl;

Line 1370: FROM oe_order_lines_all

1366:
1367: BEGIN
1368:
1369: SELECT * INTO l_model_line_rec
1370: FROM oe_order_lines_all
1371: WHERE line_id = p_model_line_id;
1372:
1373: EXCEPTION
1374: WHEN no_data_found THEN

Line 1408: from oe_order_lines_all

1404: IF l_line_tbl(l_ind).model_remnant_flag = 'Y' THEN
1405: BEGIN
1406: select sum(ordered_quantity)
1407: into l_order_line_qty
1408: from oe_order_lines_all
1409: where link_to_line_id = l_line_tbl(l_ind).link_to_line_id
1410: and inventory_item_id = l_line_tbl(l_ind).inventory_item_id
1411: and model_remnant_flag = 'Y';
1412: EXCEPTION

Line 1423: l_txn_cascade_tbl(l_tc_ind).parent_source_table := 'OE_ORDER_LINES_ALL';

1419: END IF;
1420:
1421: l_tc_ind := l_tc_ind + 1;
1422:
1423: l_txn_cascade_tbl(l_tc_ind).parent_source_table := 'OE_ORDER_LINES_ALL';
1424: l_txn_cascade_tbl(l_tc_ind).parent_source_id := p_model_line_id;
1425: l_txn_cascade_tbl(l_tc_ind).child_source_id := l_line_tbl(l_ind).line_id;
1426: --fix for bug5096435:ordered_quantity is included to have better control of qty in cascade
1427: --api while cascading txn details from model line

Line 1668: FROM oe_order_lines_all

1664: END IF;
1665: ELSE
1666: BEGIN
1667: select nvl(ordered_quantity,0) INTO l_non_ib_mdl_qty
1668: FROM oe_order_lines_all
1669: WHERE line_id = p_txn_cascade_tbl(1).parent_source_id;
1670: IF l_rem_qty <= p_txn_cascade_tbl(l_ind).quantity_ratio THEN --fix for bug 5096435
1671: l_line_dtl_tbl(l_c_td_ind).quantity := l_rem_qty;
1672: ELSE