[Home] [Help]
467: and bcol.ship_from_org_id in
468: (select assg.organization_id
469: from mrp_sr_assignments assg,
470: mrp_sr_receipt_org rcv,
471: mrp_sr_source_org src
472: where assg.inventory_item_id = bcol.config_item_id
473: and assg.sourcing_rule_id = rcv.sourcing_rule_id
474: and rcv.effective_date <= sysdate
475: and nvl(rcv.disable_date,sysdate+1)>sysdate
477: union
478: select src.source_organization_id
479: from mrp_sr_assignments assg,
480: mrp_sr_receipt_org rcv,
481: mrp_sr_source_org src
482: where assg.inventory_item_id = bcol.config_item_id
483: and assg.sourcing_rule_id = rcv.sourcing_rule_id
484: and rcv.effective_date <= sysdate
485: and nvl(rcv.disable_date,sysdate+1)>sysdate
511: and bcol.ship_from_org_id in
512: (select assg.organization_id org_id
513: from mrp_sr_assignments assg,
514: mrp_sr_receipt_org rcv,
515: mrp_sr_source_org src
516: where assg.inventory_item_id = bcol.config_item_id
517: and assg.sourcing_rule_id = rcv.sourcing_rule_id
518: and rcv.effective_date <= sysdate
519: and nvl(rcv.disable_date,sysdate+1)>sysdate
522: union
523: select src.source_organization_id org_id
524: from mrp_sr_assignments assg,
525: mrp_sr_receipt_org rcv,
526: mrp_sr_source_org src
527: where assg.inventory_item_id = bcol.config_item_id
528: and assg.sourcing_rule_id = rcv.sourcing_rule_id
529: and rcv.effective_date <= sysdate
530: and nvl(rcv.disable_date,sysdate+1)>sysdate
532: and src.source_organization_id not in
533: (Select assg.organization_id
534: from mrp_sr_assignments assg,
535: mrp_sr_receipt_org rcv,
536: mrp_sr_source_org src
537: Where assg.inventory_item_id = bcol.config_item_id
538: and assg.sourcing_rule_id = rcv.sourcing_rule_id
539: and rcv.effective_date <=sysdate
540: and nvl(rcv.disable_date,sysdate+1)>sysdate
2465: l_shipping_org_tbl(i).ship_method,
2466: l_shipping_org_tbl(i).operation,
2467: l_shipping_org_tbl(i).receiving_org_index,
2468: l_shipping_org_tbl(i).vendor_site_id
2469: from mrp_sr_source_org
2470: where sr_source_id = source_tree_rec.sr_source_id;
2471:
2472: oe_debug_pub.add('Vendor site id inserted = '||l_shipping_org_tbl(i).vendor_site_id,5);
2473: i := i + 1;
4081: src.VENDOR_ID,
4082: vend.VENDOR_SITE_CODE
4083:
4084: from mrp_sr_receipt_org rcv,
4085: mrp_sr_source_org src,
4086: mrp_sr_assignments assg,
4087: bom_cto_order_lines_gt bcol,
4088: mtl_system_items msi,
4089: ap_supplier_sites_all vend
4146: src.VENDOR_ID,
4147: vend.VENDOR_SITE_CODE
4148:
4149: from mrp_sr_receipt_org rcv,
4150: mrp_sr_source_org src,
4151: mrp_sr_assignments assg,
4152: bom_cto_order_lines_gt bcol,
4153: mtl_system_items msi,
4154: ap_supplier_sites_all vend
4677: assg.assignment_id
4678:
4679: from
4680: mrp_sr_receipt_org rcv,
4681: mrp_sr_source_org src,
4682: mrp_sr_assignments assg,
4683: mrp_sourcing_rules rule,
4684: po_vendor_sites_all vend,
4685: bom_cto_order_lines_gt bcol
4744: 'Y'
4745:
4746: from
4747: mrp_sr_receipt_org rcv,
4748: mrp_sr_source_org src,
4749: mrp_sr_assignments assg,
4750: mrp_sourcing_rules rule,
4751: po_vendor_sites_all vend,
4752: bom_cto_order_lines_gt bcol
4811: assg.assignment_id
4812:
4813: from
4814: mrp_sr_receipt_org rcv,
4815: mrp_sr_source_org src,
4816: mrp_sr_assignments assg,
4817: mrp_sourcing_rules rule,
4818: po_vendor_sites_all vend
4819: where
5324: assg.assignment_id
5325:
5326: from
5327: mrp_sr_receipt_org rcv,
5328: mrp_sr_source_org src,
5329: mrp_sr_assignments assg,
5330: mrp_sourcing_rules rule,
5331: po_vendor_sites_all vend
5332: where
5389: assg.assignment_id
5390:
5391: from
5392: mrp_sr_receipt_org rcv,
5393: mrp_sr_source_org src,
5394: mrp_sr_assignments assg,
5395: mrp_sourcing_rules rule,
5396: po_vendor_sites_all vend,
5397: bom_cto_order_lines_gt bcol
5460: 'Y'
5461:
5462: from
5463: mrp_sr_receipt_org rcv,
5464: mrp_sr_source_org src,
5465: mrp_sr_assignments assg,
5466: mrp_sourcing_rules rule,
5467: po_vendor_sites_all vend,
5468: bom_cto_order_lines_gt bcol