[Home] [Help]
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
5239: where
5240: assg.assignment_set_id = g_def_assg_set
5241: and bcol.ato_line_id = p_ato_line_id
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
5308: where
5309: assg.assignment_set_id = g_def_assg_set
5310: and bcol.ato_line_id = p_ato_line_id
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
5377: assg.assignment_set_id = g_def_assg_set
5378: and assg.inventory_item_id = p_item_id
5379: and assg.sourcing_rule_id = rcv.sourcing_rule_id
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
5998: assg.assignment_set_id = g_def_assg_set
5999: and assg.assignment_id = x_assg_list.assignment_id(i)
6000: and assg.sourcing_rule_id = rcv.sourcing_rule_id
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
6063: where
6064: assg.assignment_set_id = g_def_assg_set
6065: and bcol.ato_line_id = p_ato_line_id
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
6150: where
6151: assg.assignment_set_id = g_def_assg_set
6152: and bcol.ato_line_id = p_ato_line_id