DBA Data[Home] [Help]

APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on PO_DISTRIBUTIONS_ALL

Line 1099: from po_distributions_all

1095: and added condition on wip_line_id */
1096:
1097: select nvl(sum(nvl(quantity_delivered,0)),0)
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

Line 1139: from po_distributions_all pd

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