DBA Data[Home] [Help]

APPS.EGO_ITEM_AML_GRP dependencies on MTL_MFG_PART_NUMBERS

Line 109: l_prod_data_row MTL_MFG_PART_NUMBERS%ROWTYPE;

105: l_perform_security_check BOOLEAN;
106: l_prog_mode_history BOOLEAN;
107:
108: l_pend_data_row EGO_MFG_PART_NUM_CHGS%ROWTYPE;
109: l_prod_data_row MTL_MFG_PART_NUMBERS%ROWTYPE;
110:
111: l_msg_data VARCHAR2(4000);
112: l_msg_count NUMBER;
113: l_return_status VARCHAR2(1);

Line 411: FROM mtl_mfg_part_numbers prod

407: DECODE(intf.end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
408: NULL,prod.end_date,
409: intf.end_date),
410: NVL(p_pf_after_population,p_pf_to_process)
411: FROM mtl_mfg_part_numbers prod
412: WHERE intf.inventory_item_id = prod.inventory_item_id
413: AND intf.organization_id = prod.organization_id
414: AND intf.manufacturer_id = prod.manufacturer_id
415: AND intf.mfg_part_num = prod.mfg_part_num