APPS.GMF_LC_ADJ_TRANSACTIONS_PKG dependencies on MTL_ITEM_FLEXFIELDS

Line 926: cp_from_item mtl_item_flexfields.item_number%TYPE,

922: -- Load LC adjustments
923: CURSOR lc_adjustments_cur (cp_le_id NUMBER,
924: cp_from_org_cd mtl_parameters.organization_code%TYPE,
925: cp_to_org_cd mtl_parameters.organization_code%TYPE,
926: cp_from_item mtl_item_flexfields.item_number%TYPE,
927: cp_to_item mtl_item_flexfields.item_number%TYPE,
928: cp_start_dt DATE,
929: cp_end_dt DATE) IS
930: SELECT glah.parent_ship_line_id,

Line 927: cp_to_item mtl_item_flexfields.item_number%TYPE,

923: CURSOR lc_adjustments_cur (cp_le_id NUMBER,
924: cp_from_org_cd mtl_parameters.organization_code%TYPE,
925: cp_to_org_cd mtl_parameters.organization_code%TYPE,
926: cp_from_item mtl_item_flexfields.item_number%TYPE,
927: cp_to_item mtl_item_flexfields.item_number%TYPE,
928: cp_start_dt DATE,
929: cp_end_dt DATE) IS
930: SELECT glah.parent_ship_line_id,
931: glah.adjustment_num,

Line 968: mtl_item_flexfields mif

964: gmf_lc_adj_headers_v glah,
965: org_organization_definitions ood,
966: mtl_parameters mp,
967: rcv_parameters rp,
968: mtl_item_flexfields mif
969: WHERE
970: mp.organization_id = glah.organization_id
971: AND ood.legal_entity = cp_le_id
972: AND mp.process_enabled_flag = 'Y'

Line 1013: FROM mtl_item_flexfields

1009:
1010: -- Get item number
1011: CURSOR cur_get_item (cp_inventory_item_id NUMBER) IS
1012: SELECT item_number
1013: FROM mtl_item_flexfields
1014: WHERE inventory_item_id = cp_inventory_item_id
1015: AND rownum < 2;
1016:
1017: -- B9917469, Removing OPM_LCM dependency

Line 1033: l_from_item mtl_item_flexfields.item_number%TYPE := NULL;

1029:
1030: l_from_org_code mtl_parameters.organization_code%TYPE := NULL;
1031: l_to_org_code mtl_parameters.organization_code%TYPE := NULL;
1032:
1033: l_from_item mtl_item_flexfields.item_number%TYPE := NULL;
1034: l_to_item mtl_item_flexfields.item_number%TYPE := NULL;
1035:
1036: l_le_id NUMBER;
1037: l_le_name gmf_legal_entities.legal_entity_name%TYPE;

Line 1034: l_to_item mtl_item_flexfields.item_number%TYPE := NULL;

1030: l_from_org_code mtl_parameters.organization_code%TYPE := NULL;
1031: l_to_org_code mtl_parameters.organization_code%TYPE := NULL;
1032:
1033: l_from_item mtl_item_flexfields.item_number%TYPE := NULL;
1034: l_to_item mtl_item_flexfields.item_number%TYPE := NULL;
1035:
1036: l_le_id NUMBER;
1037: l_le_name gmf_legal_entities.legal_entity_name%TYPE;
1038: l_from_organization_id NUMBER;