APPS.WIP_OSP_SHP_I_WF dependencies on PO_DISTRIBUTIONS_ALL

Line 553: po_distributions_all pd,

549: round(wo.scheduled_quantity,
550: WIP_CONSTANTS.INV_MAX_PRECISION))) required_assy_qty
551: from po_headers_all ph,
552: po_lines_all pl,
553: po_distributions_all pd,
554: po_vendors pv,
555: po_vendor_sites_all pvs,
556: wip_operation_resources wor,
557: wip_operations wo,

Line 616: po_distributions_all pd,

612: from po_releases_all pr,
613: po_headers_all ph,
614: po_lines_all pl,
615: po_line_locations_all ps,
616: po_distributions_all pd,
617: po_vendors pv,
618: po_vendor_sites_all pvs,
619: wip_operation_resources wor,
620: wip_operations wo,

Line 1157: from po_distributions_all pd,

1153: select pd.wip_entity_id,
1154: pd.wip_repetitive_schedule_id,
1155: ps.ship_to_organization_id,
1156: pd.wip_operation_seq_num
1157: from po_distributions_all pd,
1158: po_line_locations_all ps
1159: where pd.po_distribution_id = p_po_distribution_id
1160: and ps.line_location_id = pd.line_location_id;
1161:

Line 1179: po_distributions_all pd

1175: po_vendors pv,
1176: po_headers_all ph,
1177: po_lines_all pl,
1178: po_line_locations_all ps,
1179: po_distributions_all pd
1180: where pd.po_distribution_id = p_po_distribution_id
1181: and ps.line_location_id = pd.line_location_id
1182: and pl.po_line_id = pd.po_line_id
1183: and ph.po_header_id = pd.po_header_id

Line 1401: po_distributions_all pd2,

1397: po_lines_all pl2,
1398: po_line_locations_all ps1,
1399: po_headers_all ph2,
1400: wip_operations wo,
1401: po_distributions_all pd2,
1402: po_distributions_all pd1
1403: where pd1.po_distribution_id = l_po_distribution_id
1404: and wo.wip_entity_id = pd1.wip_entity_id
1405: and wo.organization_id = pd1.destination_organization_id

Line 1402: po_distributions_all pd1

1398: po_line_locations_all ps1,
1399: po_headers_all ph2,
1400: wip_operations wo,
1401: po_distributions_all pd2,
1402: po_distributions_all pd1
1403: where pd1.po_distribution_id = l_po_distribution_id
1404: and wo.wip_entity_id = pd1.wip_entity_id
1405: and wo.organization_id = pd1.destination_organization_id
1406: and wo.operation_seq_num = pd1.wip_operation_seq_num

Line 1437: po_distributions_all pd,

1433: select pv.vendor_name,
1434: pvs.vendor_site_code
1435: from po_vendors pv,
1436: po_vendor_sites_all pvs,
1437: po_distributions_all pd,
1438: po_location_associations pla,
1439: po_line_locations_all ps
1440: where pd.po_distribution_id = l_po_distribution_id
1441: and ps.line_location_id = pd.line_location_id