APPS.MSC_ATP_PROC dependencies on MSC_TP_SITE_ID_LID

Line 372: FROM msc_tp_site_id_lid tpsite

368: END IF;
369:
370: SELECT TP_SITE_ID
371: INTO l_ship_to_site_id
372: FROM msc_tp_site_id_lid tpsite
373: WHERE tpsite.SR_TP_SITE_ID = p_customer_site_id
374: AND tpsite.SR_INSTANCE_ID = p_instance_id
375: AND tpsite.PARTNER_TYPE = 2;
376: IF PG_DEBUG in ('Y', 'C') THEN

Line 3555: FROM msc_tp_site_id_lid mtsil,

3551:
3552: SELECT mtsil.sr_tp_site_id, mtps.tp_site_code
3553: INTO l_other_cols.sr_supplier_site_id(j),
3554: l_other_cols.vendor_site_name(j)
3555: FROM msc_tp_site_id_lid mtsil,
3556: msc_trading_partner_sites mtps
3557: WHERE mtsil.tp_site_id = mtps.partner_site_id
3558: AND mtsil.sr_instance_id = l_sources.instance_id(j)
3559: AND mtsil.partner_type = 1

Line 5582: MSC_TP_SITE_ID_LID MTSIL

5578: MSC_SR_SOURCE_ORG SOURCE_ORG,
5579: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5580: MSC_SOURCING_RULES MSR,
5581: MSC_SR_ASSIGNMENTS MSRA,
5582: MSC_TP_SITE_ID_LID MTSIL
5583: WHERE
5584: MSRA.ASSIGNMENT_TYPE = 6 /* ITEM-ORG */
5585: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
5586: AND MSRA.PARTNER_ID IS NOT NULL

Line 5789: MSC_TP_SITE_ID_LID MTSIL

5785: MSC_SR_SOURCE_ORG SOURCE_ORG,
5786: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5787: MSC_SOURCING_RULES MSR,
5788: MSC_SR_ASSIGNMENTS MSRA,
5789: MSC_TP_SITE_ID_LID MTSIL
5790: WHERE
5791: MSRA.ASSIGNMENT_TYPE = 5 /* CATEGORY-ORG */
5792: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
5793: AND MSRA.PARTNER_ID IS NOT NULL

Line 5872: -- MSC_TP_SITE_ID_LID MTSIL,

5868: MSC_SR_SOURCE_ORG SOURCE_ORG,
5869: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5870: MSC_SOURCING_RULES MSR,
5871: -- MSC_TRADING_PARTNER_SITES TP,
5872: -- MSC_TP_SITE_ID_LID MTSIL,
5873: MSC_SR_ASSIGNMENTS MSRA
5874: WHERE
5875: MSRA.ASSIGNMENT_TYPE = 3 /* ITEM */
5876: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6079: -- MSC_TP_SITE_ID_LID MTSIL

6075: MSC_SR_SOURCE_ORG SOURCE_ORG,
6076: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6077: MSC_SOURCING_RULES MSR,
6078: MSC_SR_ASSIGNMENTS MSRA
6079: -- MSC_TP_SITE_ID_LID MTSIL
6080: WHERE
6081: MSRA.ASSIGNMENT_TYPE = 2 /* CATEGORY */
6082: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
6083: AND MSRA.CATEGORY_NAME = CAT.CATEGORY_NAME

Line 6161: MSC_TP_SITE_ID_LID MTSIL

6157: MSC_SR_SOURCE_ORG SOURCE_ORG,
6158: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6159: MSC_SOURCING_RULES MSR,
6160: MSC_SR_ASSIGNMENTS MSRA,
6161: MSC_TP_SITE_ID_LID MTSIL
6162: WHERE
6163: MSRA.ASSIGNMENT_TYPE = 4 /* ORG */
6164: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
6165: AND MSRA.PARTNER_ID IS NOT NULL

Line 6365: -- MSC_TP_SITE_ID_LID MTSIL

6361: MSC_SR_SOURCE_ORG SOURCE_ORG,
6362: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6363: MSC_SOURCING_RULES MSR,
6364: MSC_SR_ASSIGNMENTS MSRA
6365: -- MSC_TP_SITE_ID_LID MTSIL
6366: WHERE
6367: MSRA.ASSIGNMENT_TYPE = 1 /* GLOBAL */
6368: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
6369: AND MSRA.SOURCING_RULE_ID = MSR.SOURCING_RULE_ID

Line 6455: MSC_TP_SITE_ID_LID MTSIL,

6451: MSC_SR_SOURCE_ORG SOURCE_ORG,
6452: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6453: MSC_SOURCING_RULES MSR,
6454: MSC_SR_ASSIGNMENTS MSRA,
6455: MSC_TP_SITE_ID_LID MTSIL,
6456: MSC_SHIP_SET_TEMP MSST
6457: WHERE
6458: MSRA.ASSIGNMENT_TYPE = 6 /* ITEM-ORG */
6459: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6804: MSC_TP_SITE_ID_LID MTSIL,

6800: MSC_SR_SOURCE_ORG SOURCE_ORG,
6801: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6802: MSC_SOURCING_RULES MSR,
6803: MSC_SR_ASSIGNMENTS MSRA,
6804: MSC_TP_SITE_ID_LID MTSIL,
6805: MSC_SHIP_SET_TEMP MSST
6806: WHERE
6807: MSRA.ASSIGNMENT_TYPE = 5 /* CATEGORY-ORG */
6808: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6948: -- MSC_TP_SITE_ID_LID MTSIL,

6944: MSC_SR_SOURCE_ORG SOURCE_ORG,
6945: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6946: MSC_SOURCING_RULES MSR,
6947: MSC_SR_ASSIGNMENTS MSRA,
6948: -- MSC_TP_SITE_ID_LID MTSIL,
6949: MSC_SHIP_SET_TEMP MSST
6950: WHERE
6951:
6952: MSRA.ASSIGNMENT_TYPE = 3 /* ITEM */

Line 7280: -- MSC_TP_SITE_ID_LID MTSIL,

7276: MSC_SR_SOURCE_ORG SOURCE_ORG,
7277: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7278: MSC_SOURCING_RULES MSR,
7279: MSC_SR_ASSIGNMENTS MSRA,
7280: -- MSC_TP_SITE_ID_LID MTSIL,
7281: MSC_SHIP_SET_TEMP MSST
7282: WHERE
7283:
7284: MSRA.ASSIGNMENT_TYPE = 2 /* CATEGORY */

Line 7423: MSC_TP_SITE_ID_LID MTSIL,

7419: MSC_SR_SOURCE_ORG SOURCE_ORG,
7420: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7421: MSC_SOURCING_RULES MSR,
7422: MSC_SR_ASSIGNMENTS MSRA,
7423: MSC_TP_SITE_ID_LID MTSIL,
7424: MSC_SHIP_SET_TEMP MSST
7425: WHERE
7426: MSRA.ASSIGNMENT_TYPE = 4 /* ORG */
7427: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 7752: -- MSC_TP_SITE_ID_LID MTSIL,

7748: MSC_SR_SOURCE_ORG SOURCE_ORG,
7749: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7750: MSC_SOURCING_RULES MSR,
7751: MSC_SR_ASSIGNMENTS MSRA,
7752: -- MSC_TP_SITE_ID_LID MTSIL,
7753: MSC_SHIP_SET_TEMP MSST
7754: WHERE
7755: MSRA.ASSIGNMENT_TYPE = 1 /* GLOBAL */
7756: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id