DBA Data[Home] [Help]

APPS.INV_COST_GROUP_PVT dependencies on MTL_PARAMETERS

Line 178: FROM MTL_PARAMETERS

174: print_debug('item id:'||l_item_id||'org id:'|| l_org_id ||', xfer org id :'|| l_xfer_org_id ||',CG:'||l_cg_id||',xfrcost:'||l_transfer_cost);
175: END IF;
176:
177: SELECT NVL(primary_cost_method,1) INTO l_primary_cost_method
178: FROM MTL_PARAMETERS
179: WHERE organization_id = l_org_id ;
180:
181: IF (l_primary_cost_method = 1 ) THEN
182: IF (l_debug = 1) THEN

Line 469: FROM mtl_parameters

465: print_debug('Transaction Action' || p_mmtt_rec.transaction_action_id );
466:
467: SELECT default_cost_group_id
468: INTO l_org_cost_group_id
469: FROM mtl_parameters
470: WHERE organization_id = p_mmtt_rec.organization_id;
471:
472: print_debug('After selecting the default cost group');
473: print_debug('Cost Group ID' || l_org_cost_group_id);

Line 479: FROM mtl_parameters

475: IF (p_mmtt_rec.transfer_organization IS NOT NULL) THEN
476: print_debug('Transfer Org. is being populated');
477: SELECT default_cost_group_id
478: INTO l_tfr_org_cost_group_id
479: FROM mtl_parameters
480: WHERE organization_id = p_mmtt_rec.transfer_organization;
481: END IF;
482:
483: print_debug('After selecting the default transfer cost group');

Line 811: FROM mtl_parameters

807: SELECT default_cost_group_id,
808: primary_cost_method
809: INTO l_tfr_org_cost_group_id,
810: l_tfr_primary_cost_method
811: FROM mtl_parameters
812: WHERE organization_id = l_transfer_organization_id;
813: IF( l_from_locator_id IS NOT NULL) then
814: BEGIN
815: SELECT project_id INTO l_from_project_id

Line 869: FROM mtl_parameters

865: SELECT default_cost_group_id,
866: primary_cost_method
867: INTO l_org_cost_group_id,
868: l_primary_cost_method
869: FROM mtl_parameters
870: WHERE organization_id = l_organization_id;
871:
872: IF (l_debug = 1) THEN
873: print_debug('l_org_cost_group_id: ' || l_org_cost_group_id);