APPS.WIP_OSP_SHP_I_WF dependencies on PO_DISTRIBUTIONS_ALL

Line 596: po_distributions_all pd,

592: round(wo.scheduled_quantity,
593: WIP_CONSTANTS.INV_MAX_PRECISION))) required_assy_qty
594: from po_headers_all ph,
595: po_lines_all pl,
596: po_distributions_all pd,
597: po_vendors pv,
598: po_vendor_sites_all pvs,
599: wip_operation_resources wor,
600: wip_operations wo,

Line 659: po_distributions_all pd,

655: from po_releases_all pr,
656: po_headers_all ph,
657: po_lines_all pl,
658: po_line_locations_all ps,
659: po_distributions_all pd,
660: po_vendors pv,
661: po_vendor_sites_all pvs,
662: wip_operation_resources wor,
663: wip_operations wo,

Line 1200: from po_distributions_all pd,

1196: select pd.wip_entity_id,
1197: pd.wip_repetitive_schedule_id,
1198: ps.ship_to_organization_id,
1199: pd.wip_operation_seq_num
1200: from po_distributions_all pd,
1201: po_line_locations_all ps
1202: where pd.po_distribution_id = p_po_distribution_id
1203: and ps.line_location_id = pd.line_location_id;
1204:

Line 1222: po_distributions_all pd

1218: po_vendors pv,
1219: po_headers_all ph,
1220: po_lines_all pl,
1221: po_line_locations_all ps,
1222: po_distributions_all pd
1223: where pd.po_distribution_id = p_po_distribution_id
1224: and ps.line_location_id = pd.line_location_id
1225: and pl.po_line_id = pd.po_line_id
1226: and ph.po_header_id = pd.po_header_id

Line 1444: po_distributions_all pd2,

1440: po_lines_all pl2,
1441: po_line_locations_all ps1,
1442: po_headers_all ph2,
1443: wip_operations wo,
1444: po_distributions_all pd2,
1445: po_distributions_all pd1
1446: where pd1.po_distribution_id = l_po_distribution_id
1447: and wo.wip_entity_id = pd1.wip_entity_id
1448: and wo.organization_id = pd1.destination_organization_id

Line 1445: po_distributions_all pd1

1441: po_line_locations_all ps1,
1442: po_headers_all ph2,
1443: wip_operations wo,
1444: po_distributions_all pd2,
1445: po_distributions_all pd1
1446: where pd1.po_distribution_id = l_po_distribution_id
1447: and wo.wip_entity_id = pd1.wip_entity_id
1448: and wo.organization_id = pd1.destination_organization_id
1449: and wo.operation_seq_num = pd1.wip_operation_seq_num

Line 1480: po_distributions_all pd,

1476: select pv.vendor_name,
1477: pvs.vendor_site_code
1478: from po_vendors pv,
1479: po_vendor_sites_all pvs,
1480: po_distributions_all pd,
1481: po_location_associations pla,
1482: po_line_locations_all ps
1483: where pd.po_distribution_id = l_po_distribution_id
1484: and ps.line_location_id = pd.line_location_id