[Home] [Help]
508: and bcol.ship_from_org_id in
509: (select assg.organization_id
510: from mrp_sr_assignments assg,
511: mrp_sr_receipt_org rcv,
512: mrp_sr_source_org src
513: where assg.inventory_item_id = bcol.config_item_id
514: and assg.sourcing_rule_id = rcv.sourcing_rule_id
515: and rcv.effective_date <= sysdate
516: and nvl(rcv.disable_date,sysdate+1)>sysdate
518: union
519: select src.source_organization_id
520: from mrp_sr_assignments assg,
521: mrp_sr_receipt_org rcv,
522: mrp_sr_source_org src
523: where assg.inventory_item_id = bcol.config_item_id
524: and assg.sourcing_rule_id = rcv.sourcing_rule_id
525: and rcv.effective_date <= sysdate
526: and nvl(rcv.disable_date,sysdate+1)>sysdate
552: and bcol.ship_from_org_id in
553: (select assg.organization_id org_id
554: from mrp_sr_assignments assg,
555: mrp_sr_receipt_org rcv,
556: mrp_sr_source_org src
557: where assg.inventory_item_id = bcol.config_item_id
558: and assg.sourcing_rule_id = rcv.sourcing_rule_id
559: and rcv.effective_date <= sysdate
560: and nvl(rcv.disable_date,sysdate+1)>sysdate
563: union
564: select src.source_organization_id org_id
565: from mrp_sr_assignments assg,
566: mrp_sr_receipt_org rcv,
567: mrp_sr_source_org src
568: where assg.inventory_item_id = bcol.config_item_id
569: and assg.sourcing_rule_id = rcv.sourcing_rule_id
570: and rcv.effective_date <= sysdate
571: and nvl(rcv.disable_date,sysdate+1)>sysdate
573: and src.source_organization_id not in
574: (Select assg.organization_id
575: from mrp_sr_assignments assg,
576: mrp_sr_receipt_org rcv,
577: mrp_sr_source_org src
578: Where assg.inventory_item_id = bcol.config_item_id
579: and assg.sourcing_rule_id = rcv.sourcing_rule_id
580: and rcv.effective_date <=sysdate
581: and nvl(rcv.disable_date,sysdate+1)>sysdate
2743: l_shipping_org_tbl(i).ship_method,
2744: l_shipping_org_tbl(i).operation,
2745: l_shipping_org_tbl(i).receiving_org_index,
2746: l_shipping_org_tbl(i).vendor_site_id
2747: from mrp_sr_source_org
2748: where sr_source_id = source_tree_rec.sr_source_id;
2749:
2750: oe_debug_pub.add('Vendor site id inserted = '||l_shipping_org_tbl(i).vendor_site_id,5);
2751: i := i + 1;
4605: src.VENDOR_ID,
4606: vend.VENDOR_SITE_CODE
4607:
4608: from mrp_sr_receipt_org rcv,
4609: mrp_sr_source_org src,
4610: mrp_sr_assignments assg,
4611: bom_cto_order_lines_gt bcol,
4612: mtl_system_items msi,
4613: ap_supplier_sites_all vend
4670: src.VENDOR_ID,
4671: vend.VENDOR_SITE_CODE
4672:
4673: from mrp_sr_receipt_org rcv,
4674: mrp_sr_source_org src,
4675: mrp_sr_assignments assg,
4676: bom_cto_order_lines_gt bcol,
4677: mtl_system_items msi,
4678: ap_supplier_sites_all vend
5230: assg.assignment_id
5231:
5232: from
5233: mrp_sr_receipt_org rcv,
5234: mrp_sr_source_org src,
5235: mrp_sr_assignments assg,
5236: mrp_sourcing_rules rule,
5237: po_vendor_sites_all vend,
5238: bom_cto_order_lines_gt bcol
5299: 'Y'
5300:
5301: from
5302: mrp_sr_receipt_org rcv,
5303: mrp_sr_source_org src,
5304: mrp_sr_assignments assg,
5305: mrp_sourcing_rules rule,
5306: po_vendor_sites_all vend,
5307: bom_cto_order_lines_gt bcol
5368: assg.assignment_id
5369:
5370: from
5371: mrp_sr_receipt_org rcv,
5372: mrp_sr_source_org src,
5373: mrp_sr_assignments assg,
5374: mrp_sourcing_rules rule,
5375: po_vendor_sites_all vend
5376: where
5989: assg.assignment_id
5990:
5991: from
5992: mrp_sr_receipt_org rcv,
5993: mrp_sr_source_org src,
5994: mrp_sr_assignments assg,
5995: mrp_sourcing_rules rule,
5996: po_vendor_sites_all vend
5997: where
6054: assg.assignment_id
6055:
6056: from
6057: mrp_sr_receipt_org rcv,
6058: mrp_sr_source_org src,
6059: mrp_sr_assignments assg,
6060: mrp_sourcing_rules rule,
6061: po_vendor_sites_all vend,
6062: bom_cto_order_lines_gt bcol
6141: 'Y'
6142:
6143: from
6144: mrp_sr_receipt_org rcv,
6145: mrp_sr_source_org src,
6146: mrp_sr_assignments assg,
6147: mrp_sourcing_rules rule,
6148: po_vendor_sites_all vend,
6149: bom_cto_order_lines_gt bcol