[Home] [Help]
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
4686: where
4687: assg.assignment_set_id = g_def_assg_set
4688: and bcol.ato_line_id = p_ato_line_id
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
4753: where
4754: assg.assignment_set_id = g_def_assg_set
4755: and bcol.ato_line_id = p_ato_line_id
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
4820: assg.assignment_set_id = g_def_assg_set
4821: and assg.inventory_item_id = p_item_id
4822: and assg.sourcing_rule_id = rcv.sourcing_rule_id
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
5333: assg.assignment_set_id = g_def_assg_set
5334: and assg.assignment_id = x_assg_list.assignment_id(i)
5335: and assg.sourcing_rule_id = rcv.sourcing_rule_id
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
5398: where
5399: assg.assignment_set_id = g_def_assg_set
5400: and bcol.ato_line_id = p_ato_line_id
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
5469: where
5470: assg.assignment_set_id = g_def_assg_set
5471: and bcol.ato_line_id = p_ato_line_id