APPS.EGO_ITEM_AML_PVT dependencies on MTL_MFG_PART_NUMBERS

Line 571: from mtl_mfg_part_numbers part_num

567: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
568: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
569: AND EXISTS
570: (Select 'x'
571: from mtl_mfg_part_numbers part_num
572: where part_num.inventory_item_id = aml_intf.inventory_item_id
573: and part_num.organization_id = aml_intf.organization_id
574: and part_num.manufacturer_id = aml_intf.manufacturer_id
575: and part_num.mfg_part_num = aml_intf.mfg_part_num

Line 591: from mtl_mfg_part_numbers part_num

587: ,EGO_ITEM_PUB.G_TTYPE_DELETE
588: )
589: AND NOT EXISTS
590: (Select 'x'
591: from mtl_mfg_part_numbers part_num
592: where part_num.inventory_item_id = aml_intf.inventory_item_id
593: and part_num.organization_id = aml_intf.organization_id
594: and part_num.manufacturer_id = aml_intf.manufacturer_id
595: and part_num.mfg_part_num = aml_intf.mfg_part_num

Line 609: from mtl_mfg_part_numbers part_num

605: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
606: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_SYNC
607: AND EXISTS
608: (Select 'x'
609: from mtl_mfg_part_numbers part_num
610: where part_num.inventory_item_id = aml_intf.inventory_item_id
611: and part_num.organization_id = aml_intf.organization_id
612: and part_num.manufacturer_id = aml_intf.manufacturer_id
613: and part_num.mfg_part_num = aml_intf.mfg_part_num

Line 1207: FROM mtl_mfg_part_numbers prod

1203: intf.start_date),
1204: DECODE(intf.end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
1205: NULL,prod.end_date,
1206: intf.end_date)
1207: FROM mtl_mfg_part_numbers prod
1208: WHERE intf.inventory_item_id = prod.inventory_item_id
1209: AND intf.organization_id = prod.organization_id
1210: AND intf.manufacturer_id = prod.manufacturer_id
1211: AND intf.mfg_part_num = prod.mfg_part_num

Line 1562: ,flexfield_name => 'MTL_MFG_PART_NUMBERS'

1558: IF l_count <> 0 THEN
1559: -- validate the flex field
1560: FND_DFLEX.get_flexfield
1561: (appl_short_name => 'INV'
1562: ,flexfield_name => 'MTL_MFG_PART_NUMBERS'
1563: ,flexfield => l_dflex_r
1564: ,flexinfo => l_dflex_dr
1565: );
1566: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT

Line 1671: ,desc_flex_name => 'MTL_MFG_PART_NUMBERS'

1667: ,p_message => 'Calling FND_FLEX_DESCVAL.validate_desccols'
1668: );
1669: IF NOT FND_FLEX_DESCVAL.validate_desccols
1670: (appl_short_name => 'INV'
1671: ,desc_flex_name => 'MTL_MFG_PART_NUMBERS'
1672: -- ,values_or_ids IN VARCHAR2 DEFAULT 'I'
1673: -- ,validation_date IN DATE DEFAULT SYSDATE
1674: -- ,enabled_activation IN BOOLEAN DEFAULT TRUE
1675: -- ,resp_appl_id IN NUMBER DEFAULT NULL

Line 1826: INSERT INTO mtl_mfg_part_numbers

1822: x_return_status := FND_API.G_RET_STS_SUCCESS;
1823: x_msg_count := 0;
1824: x_msg_data := NULL;
1825: l_api_name := 'populateProductionTable';
1826: INSERT INTO mtl_mfg_part_numbers
1827: (manufacturer_id
1828: ,mfg_part_num
1829: ,inventory_item_id
1830: ,organization_id

Line 1901: UPDATE mtl_mfg_part_numbers prod SET

1897: ,p_module => l_api_name
1898: ,p_message => 'Insert into production table done'
1899: );
1900:
1901: UPDATE mtl_mfg_part_numbers prod SET
1902: (mrp_planning_code
1903: ,description
1904: ,attribute_category
1905: ,attribute1

Line 1978: DELETE mtl_mfg_part_numbers prod

1974: ,p_module => l_api_name
1975: ,p_message => 'Update into production table done'
1976: );
1977:
1978: DELETE mtl_mfg_part_numbers prod
1979: WHERE EXISTS
1980: (Select 1
1981: From ego_aml_intf intf
1982: Where intf.data_set_id = p_data_set_id

Line 2523: l_prod_data_row MTL_MFG_PART_NUMBERS%ROWTYPE;

2519: l_perform_security_check BOOLEAN;
2520: l_prog_mode_history BOOLEAN;
2521:
2522: l_pend_data_row EGO_MFG_PART_NUM_CHGS%ROWTYPE;
2523: l_prod_data_row MTL_MFG_PART_NUMBERS%ROWTYPE;
2524:
2525: l_msg_data VARCHAR2(4000);
2526: l_msg_count NUMBER;
2527: l_return_status VARCHAR2(1);