APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on RCV_TRANSACTIONS

Line 393: rcv_transactions_interface rti

389: INTO
390: l_primary_quantity
391: FROM
392: mtl_system_items msi,
393: rcv_transactions_interface rti
394: WHERE rti.interface_transaction_id = g_OSP_rec.source_line_id
395: AND msi.inventory_item_id = rti.item_id
396: AND msi.organization_id = g_OSP_rec.organization_id;
397:

Line 1187: from rcv_transactions rt

1183: ( select pd.po_header_id, pd.po_line_id
1184: from po_distributions_all pd
1185: where pd.po_distribution_id =
1186: ( select rt.po_distribution_id
1187: from rcv_transactions rt
1188: where rt.wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1189: and nvl(rt.wip_repetitive_schedule_id, -1)
1190: = nvl(g_ShopFloorMove_rec.repetitive_schedule_id, -1)
1191: and rt.organization_id = g_ShopFloorMove_rec.organization_id

Line 1209: FROM rcv_transactions

1205:
1206: begin
1207: SELECT interface_transaction_id
1208: INTO l_interface_txn_id
1209: FROM rcv_transactions
1210: WHERE transaction_id = g_osp_rec.rcv_transaction_id;
1211: exception
1212: when others then
1213: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from RT');

Line 1223: FROM rcv_transactions_interface

1219:
1220: begin
1221: SELECT item_id
1222: INTO l_osp_item_id
1223: FROM rcv_transactions_interface
1224: WHERE interface_transaction_id = l_interface_txn_id;
1225: exception
1226: when others then
1227: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from RTI');