[Home] [Help]
507: and msi.option_specific_sourced is not null
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
517: and rcv.SR_RECEIPT_ID = src.sr_receipt_id
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
551: and msi.option_specific_sourced is not null
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
562: and src.source_type in (2,3)
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
572: and rcv.SR_RECEIPT_ID = src.sr_receipt_id
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
2620: l_receiving_org_tbl(rcv_count).effective_date,
2621: l_receiving_org_tbl(rcv_count).receipt_organization_id,
2622: l_receiving_org_tbl(rcv_count).operation,
2623: l_receiving_org_tbl(rcv_count).sourcing_rule_id
2624: from mrp_sr_receipt_org
2625: where sr_receipt_id = source_tree_rec.sr_receipt_id;
2626:
2627: --Bugfix 13362916
2628: l_sr_receipt_id_cache_tbl(source_tree_rec.sr_receipt_id) := rcv_count;
4604: src.source_organization_id,
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,
4669: src.source_organization_id,
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,
5229: src.sr_source_id,
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,
5298: assg.assignment_id,
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,
5367: src.sr_source_id,
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
5988: src.sr_source_id,
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
6053: src.sr_source_id,
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,
6140: assg.assignment_id,
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,