APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on RCV_TRANSACTIONS

Line 357: rcv_transactions_interface rti

353: INTO
354: l_primary_quantity
355: FROM
356: mtl_system_items msi,
357: rcv_transactions_interface rti
358: WHERE rti.interface_transaction_id = g_OSP_rec.source_line_id
359: AND msi.inventory_item_id = rti.item_id
360: AND msi.organization_id = g_OSP_rec.organization_id;
361:

Line 1102: from rcv_transactions rt

1098: into l_total_po_qty_delivered
1099: from po_distributions_all
1100: where po_distribution_id in
1101: ( select distinct rt.po_distribution_id
1102: from rcv_transactions rt
1103: where rt.wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1104: /*and nvl(rt.wip_repetitive_schedule_id, -1)
1105: = nvl(g_ShopFloorMove_rec.repetitive_schedule_id, -1) */
1106: and nvl(rt.wip_line_id,-1) = nvl(g_osp_rec.line_id,-1)

Line 1142: from rcv_transactions rt

1138: ( select pd.po_header_id, pd.po_line_id
1139: from po_distributions_all pd
1140: where pd.po_distribution_id in
1141: ( select distinct rt.po_distribution_id
1142: from rcv_transactions rt
1143: where rt.wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1144: and nvl(rt.wip_repetitive_schedule_id, -1)
1145: = nvl(g_ShopFloorMove_rec.repetitive_schedule_id, -1)
1146: and rt.organization_id = g_ShopFloorMove_rec.organization_id

Line 1163: FROM rcv_transactions

1159:
1160: begin
1161: SELECT interface_transaction_id
1162: INTO l_interface_txn_id
1163: FROM rcv_transactions
1164: WHERE transaction_id = g_osp_rec.rcv_transaction_id;
1165: exception
1166: when others then
1167: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from RT');

Line 1177: FROM rcv_transactions_interface

1173:
1174: begin
1175: SELECT item_id
1176: INTO l_osp_item_id
1177: FROM rcv_transactions_interface
1178: WHERE interface_transaction_id = l_interface_txn_id;
1179: exception
1180: when others then
1181: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from RTI');