[Home] [Help]
466: and msi.option_specific_sourced is not null
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
476: and rcv.SR_RECEIPT_ID = src.sr_receipt_id
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
510: and msi.option_specific_sourced is not null
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
521: and src.source_type in (2,3)
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
531: and rcv.SR_RECEIPT_ID = src.sr_receipt_id
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
2359: l_receiving_org_tbl(rcv_count).effective_date,
2360: l_receiving_org_tbl(rcv_count).receipt_organization_id,
2361: l_receiving_org_tbl(rcv_count).operation,
2362: l_receiving_org_tbl(rcv_count).sourcing_rule_id
2363: from mrp_sr_receipt_org
2364: where sr_receipt_id = source_tree_rec.sr_receipt_id;
2365: rcv_count := rcv_count + 1;
2366: l_curr_rcv_org := source_tree_rec.sr_receipt_id;
2367:
4080: src.source_organization_id,
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,
4145: src.source_organization_id,
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,
4676: src.sr_source_id,
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,
4743: assg.assignment_id,
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,
4810: src.sr_source_id,
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
5323: src.sr_source_id,
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
5388: src.sr_source_id,
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,
5459: assg.assignment_id,
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,