APPS.MSD_CL_PRE_PROCESS dependencies on MSD_LEVEL_ASSOCIATIONS

Line 2662: p_token_value2 => 'MSD_LEVEL_ASSOCIATIONS',

2658: p_token1 => 'COLUMN_NAMES',
2659: p_token_value1 => 'SR_INSTANCE_CODE AND'
2660: ||' CUSTOMER AND SHIP_TO_LOC',
2661: p_token2 => 'MASTER_TABLE',
2662: p_token_value2 => 'MSD_LEVEL_ASSOCIATIONS',
2663: p_token3 => 'CHILD_TABLE',
2664: p_token_value3 => 'MSD_ST_BOOKING_DATA');
2665:
2666: IF lv_return <> 0 THEN

Line 2684: FROM msd_level_associations mla

2680: AND mbd.sr_ship_to_loc_pk = msla.sr_level_pk
2681: AND msla.instance = p_instance_id
2682: UNION ALL
2683: SELECT 1
2684: FROM msd_level_associations mla
2685: WHERE mla.level_id = 11
2686: AND mla.parent_level_id = 15
2687: AND mbd.sr_customer_pk = mla.sr_parent_level_pk
2688: AND mbd.sr_ship_to_loc_pk = mla.sr_level_pk

Line 3554: p_token_value2 => 'MSD_LEVEL_ASSOCIATIONS',

3550: p_token1 => 'COLUMN_NAMES',
3551: p_token_value1 => 'SR_INSTANCE_CODE AND'
3552: ||' CUSTOMER AND SHIP_TO_LOC',
3553: p_token2 => 'MASTER_TABLE',
3554: p_token_value2 => 'MSD_LEVEL_ASSOCIATIONS',
3555: p_token3 => 'CHILD_TABLE',
3556: p_token_value3 => 'MSD_ST_SHIPMENT_DATA');
3557:
3558: IF lv_return <> 0 THEN

Line 3575: FROM msd_level_associations mla

3571: AND msd.sr_ship_to_loc_pk = msla.sr_level_pk
3572: AND msla.instance = p_instance_id
3573: UNION ALL
3574: SELECT 1
3575: FROM msd_level_associations mla
3576: WHERE mla.level_id = 11
3577: AND mla.parent_level_id = 15
3578: AND msd.sr_customer_pk = mla.sr_parent_level_pk
3579: AND msd.sr_ship_to_loc_pk = mla.sr_level_pk