DBA Data[Home] [Help]

APPS.GMF_LC_ADJ_TRANSACTIONS_PKG dependencies on MTL_PARAMETERS

Line 924: cp_from_org_cd mtl_parameters.organization_code%TYPE,

920:
921:
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,

Line 925: cp_to_org_cd mtl_parameters.organization_code%TYPE,

921:
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

Line 966: mtl_parameters mp,

962: rp.lcm_account_id lc_absorption_account_id
963: FROM
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

Line 1007: FROM mtl_parameters

1003:
1004: -- Get organization code
1005: CURSOR cur_get_org_cd (cp_organization_id NUMBER) IS
1006: SELECT organization_code
1007: FROM mtl_parameters
1008: WHERE organization_id = cp_organization_id ;
1009:
1010: -- Get item number
1011: CURSOR cur_get_item (cp_inventory_item_id NUMBER) IS

Line 1030: l_from_org_code mtl_parameters.organization_code%TYPE := NULL;

1026:
1027: l_proc_name VARCHAR2(40) := 'Process_Lc_Adjustments';
1028: l_return_status VARCHAR2(1) ;
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;

Line 1031: l_to_org_code mtl_parameters.organization_code%TYPE := NULL;

1027: l_proc_name VARCHAR2(40) := 'Process_Lc_Adjustments';
1028: l_return_status VARCHAR2(1) ;
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: