DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_SYS_PARAMETERS

Line 2411: AND ctg.organization_id = oe_sys_parameters.value('MASTER_ORGANIZATION_ID', G_ORG_ID) --G_ORG_ID

2407: AND ln.open_flag = 'Y'
2408: AND (ln.invoiced_quantity IS NULL OR ln.invoiced_quantity = 0)
2409: AND ctg.category_set_id = G_category_set_id
2410: --Bug 7651089
2411: AND ctg.organization_id = oe_sys_parameters.value('MASTER_ORGANIZATION_ID', G_ORG_ID) --G_ORG_ID
2412: AND ctg.inventory_item_id = ln.inventory_item_id
2413: AND trm.term_id = ln.payment_term_id
2414: AND ln.line_category_code = 'ORDER'
2415: AND trm.credit_check_flag = 'Y'

Line 3812: := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', G_ORG_ID);

3808: /* Start MOAC CREDIT CHECK CHANGE */
3809: /*
3810: x_system_parameter_rec.org_id := G_ORG_ID;
3811: x_system_parameter_rec.master_organization_id
3812: := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', G_ORG_ID);
3813: x_system_parameter_rec.customer_relationships_flag
3814: :=oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG', G_ORG_ID);
3815: -- End Sys Param Change
3816:

Line 3814: :=oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG', G_ORG_ID);

3810: x_system_parameter_rec.org_id := G_ORG_ID;
3811: x_system_parameter_rec.master_organization_id
3812: := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', G_ORG_ID);
3813: x_system_parameter_rec.customer_relationships_flag
3814: :=oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG', G_ORG_ID);
3815: -- End Sys Param Change
3816:
3817: EXCEPTION
3818: WHEN NO_DATA_FOUND