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_ORDER_SHIP_PUB dependencies on OE_ORDER_LINES_ALL

Line 34: oe_order_lines_all oel

30: IS
31: CURSOR ato_option_cur(p_ato_line_id in number) IS
32: SELECT oel.line_id
33: FROM mtl_system_items msi,
34: oe_order_lines_all oel
35: WHERE oel.ato_line_id = p_ato_line_id
36: AND oel.item_type_code = 'OPTION'
37: AND nvl(oel.cancelled_flag,'N') <> 'Y'
38: AND msi.inventory_item_id = oel.inventory_item_id

Line 194: FROM oe_order_lines_all

190:
191: -- create tld records with respect to the parent/child ratio
192: SELECT ordered_quantity
193: INTO l_parent_ord_qty
194: FROM oe_order_lines_all
195: WHERE line_id = p_order_line_rec.link_to_line_id;
196:
197: l_end_loop := l_parent_ord_qty;
198: l_quantity := p_order_line_rec.ordered_quantity/l_parent_ord_qty;

Line 394: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'

390:
391: SELECT transaction_line_id
392: INTO l_transaction_line_id
393: FROM csi_t_transaction_lines
394: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'
395: AND source_transaction_id = p_order_line_rec.order_line_id;
396:
397: SELECT sum(abs(quantity))
398: INTO l_total_tld_quantity

Line 711: l_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';

707: debug(' default sub_type_id: '||x_trx_sub_type_rec.sub_type_id );
708:
709: /* assign the parameter for txn_line_rec */
710: l_txn_line_rec.source_transaction_id := l_order_line_rec.order_line_id;
711: l_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
712:
713: -- Check if txn details exist
714: l_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(
715: p_txn_line_rec => l_txn_line_rec );

Line 753: p_source_trx_table => 'OE_ORDER_LINES_ALL',

749: END IF;
750:
751: csi_utl_pkg.cascade_txn_dtls(
752: p_source_trx_id => l_order_line_rec.order_line_id,
753: p_source_trx_table => 'OE_ORDER_LINES_ALL',
754: p_ratio => l_qty_ratio,
755: x_return_status => x_return_status);
756:
757: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 799: l_src_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';

795: debug(' No it is not. Copying installation details as WSH_DELIVERY_DETAILS.');
796:
797: --Parameters for the source order line
798: l_src_txn_line_rec.source_transaction_id := l_order_line_rec.order_line_id;
799: l_src_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
800:
801: --Parameters for the new source trx rec
802: l_new_txn_line_rec.source_transaction_id := l_order_line_rec.order_line_id;
803: l_new_txn_line_rec.source_transaction_table := 'WSH_DELIVERY_DETAILS';

Line 879: l_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';

875: raise fnd_api.g_exc_error;
876: END IF;
877:
878: l_txn_line_rec.source_transaction_id := l_order_line_rec.order_line_id;
879: l_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
880:
881: debug('check if installation details are cascaded from the model ?');
882:
883: -- Check if txn details exist

Line 912: p_source_trx_table => 'OE_ORDER_LINES_ALL',

908: END IF;
909:
910: csi_utl_pkg.cascade_txn_dtls(
911: p_source_trx_id => l_order_line_rec.order_line_id,
912: p_source_trx_table => 'OE_ORDER_LINES_ALL',
913: p_ratio => l_qty_ratio ,
914: x_return_status => l_return_status );
915:
916: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 956: l_src_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';

952: debug(' No it is not. Copying installation details as WSH_DELIVERY_DETAILS.');
953:
954: --Parameters for the source order line
955: l_src_txn_line_rec.source_transaction_id := l_order_line_rec.order_line_id;
956: l_src_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
957:
958: --Parameters for the new source trx rec
959: l_new_txn_line_rec.source_transaction_id := l_order_line_rec.order_line_id;
960: l_new_txn_line_rec.source_transaction_table := 'WSH_DELIVERY_DETAILS';

Line 1036: l_copy_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';

1032: l_order_line_rec.split_ord_line_id := l_split_ord_line_id;
1033:
1034: /* assign the parameter for txn_line_rec */
1035: l_copy_txn_line_rec.source_transaction_id := l_split_ord_line_id;
1036: l_copy_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
1037:
1038: debug('Check if copied installation details exist for the split order line?' );
1039:
1040: l_copy_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(

Line 1051: l_src_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';

1047: /*------------------------------------------------------------------------*/
1048:
1049: --Parameters for the source transaction
1050: l_src_txn_line_rec.source_transaction_id := l_order_line_rec.order_line_id;
1051: l_src_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
1052:
1053: --Parameters for the destination trx rec
1054: l_new_txn_line_rec.source_transaction_id := l_split_ord_line_id;
1055: l_new_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';

Line 1055: l_new_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';

1051: l_src_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
1052:
1053: --Parameters for the destination trx rec
1054: l_new_txn_line_rec.source_transaction_id := l_split_ord_line_id;
1055: l_new_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
1056: l_new_txn_line_rec.source_transaction_type_id := g_txn_type_id;
1057: l_new_txn_line_rec.transaction_line_id := fnd_api.g_miss_num;
1058:
1059: debug(' No. So copying installation details for the split order line.' );

Line 1724: oe_order_lines_all ool,

1720: to_char(null) ib_current_loc,
1721: to_number(null) ib_current_loc_id,
1722: ooh.order_source_id order_source_id -- Added for Siebel Genesis Project
1723: FROM oe_order_headers_all ooh,
1724: oe_order_lines_all ool,
1725: mtl_system_items msi,
1726: mtl_unit_transactions mut,
1727: mtl_material_transactions mmt,
1728: mtl_secondary_inventories msei,

Line 1783: oe_order_lines_all ool,

1779: to_char(null) ib_current_loc,
1780: to_number(null) ib_current_loc_id,
1781: ooh.order_source_id order_source_id -- Added for Siebel Genesis Project
1782: FROM oe_order_headers_all ooh,
1783: oe_order_lines_all ool,
1784: mtl_system_items msi,
1785: mtl_unit_transactions mut,
1786: mtl_transaction_lot_numbers mtln,
1787: mtl_material_transactions mmt,

Line 4154: l_order_line_rec oe_order_lines_all%rowtype;

4150: l_party_site_id number;
4151: l_owner_party_id number;
4152: l_owner_account_id number;
4153:
4154: l_order_line_rec oe_order_lines_all%rowtype;
4155: l_order_header_rec oe_order_headers_all%rowtype;
4156:
4157: l_location_type_code varchar2(80);
4158: l_inst_object_ver_num number;

Line 4191: FROM oe_order_lines_all

4187: FROM csi_item_instances
4188: WHERE instance_id = p_instance_id;
4189:
4190: SELECT * INTO l_order_line_rec
4191: FROM oe_order_lines_all
4192: WHERE line_id = p_line_id;
4193:
4194: SELECT * INTO l_order_header_rec
4195: FROM oe_order_headers_all

Line 4719: l_literal2 VARCHAR2(30) := 'OE_ORDER_LINES_ALL' ;

4715: l_order_quantity number;
4716: l_total_qty number := 0;
4717: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4718: l_literal1 VARCHAR2(30) := 'PROCESSED' ;
4719: l_literal2 VARCHAR2(30) := 'OE_ORDER_LINES_ALL' ;
4720: BEGIN
4721:
4722: x_return_status := fnd_api.g_ret_sts_success;
4723: api_log('proc_for_last_mtl_trx');