DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_TRADING_PARTNERS

Line 1487: from msc_trading_partners

1483: -- dsting dlt
1484: --13032665 start check if the internal/destination org has been collected.
1485: IF (l_atp_table.internal_org_id(i) IS NOT NULL) THEN
1486: select count(*) into l_org_collected
1487: from msc_trading_partners
1488: where sr_tp_id = l_atp_table.internal_org_id(i)
1489: and sr_instance_id = p_instance_id
1490: and partner_type = 3;
1491:

Line 7332: msc_trading_partners P,

7328: BEGIN
7329: SELECT NVL(r.demand_class_atp_flag, 0)
7330: INTO l_demand_class_flag
7331: FROM msc_system_items I,
7332: msc_trading_partners P,
7333: msc_atp_rules R
7334: WHERE I.sr_instance_id = p_atp_record.instance_id
7335: AND I.organization_id = p_atp_record.organization_id
7336: AND I.sr_inventory_item_id = p_atp_record.inventory_item_id