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.WIP_DEFAULT_SHOPFLOORMOVE dependencies on PO_DISTRIBUTIONS_ALL

Line 1137: FROM po_distributions_all pda

1133: /*Changed this SQL for performance bug 9888616. */
1134: IF g_ShopFloorMove_rec.repetitive_schedule_id IS NULL THEN
1135: SELECT sum(quantity_delivered)
1136: INTO l_total_po_qty_delivered
1137: FROM po_distributions_all pda
1138: WHERE pda.wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1139: AND pda.destination_organization_id = g_ShopFloorMove_rec.organization_id
1140: AND pda.wip_operation_seq_num = g_ShopFloorMove_rec.fm_operation_seq_num
1141: AND pda.wip_resource_seq_num = g_OSP_rec.resource_seq_num

Line 1146: FROM po_distributions_all pda

1142: AND pda.quantity_delivered IS NOT NULL;
1143: ELSE
1144: SELECT sum(quantity_delivered)
1145: INTO l_total_po_qty_delivered
1146: FROM po_distributions_all pda
1147: WHERE pda.wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1148: AND pda.wip_line_id = g_osp_rec.line_id
1149: AND pda.destination_organization_id = g_ShopFloorMove_rec.organization_id
1150: AND pda.wip_operation_seq_num = g_ShopFloorMove_rec.fm_operation_seq_num

Line 1184: from po_distributions_all pd

1180: ( select PL.unit_meas_lookup_code
1181: from po_lines_all Pl
1182: where (pl.po_header_id,pl.po_line_id) =
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