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 468: FROM mtl_parameters

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

Line 478: FROM mtl_parameters

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

Line 810: FROM mtl_parameters

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

Line 868: FROM mtl_parameters

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