APPS.RCV_RMA_TRANSACTIONS dependencies on OE_SYS_PARAMETERS

Line 36: AND msi.organization_id = oe_sys_parameters.VALUE('MASTER_ORGANIZATION_ID', oel.org_id)

32: AND oeh.open_flag = 'Y'
33: AND oel.line_category_code = 'RETURN'
34: AND oel.open_flag = 'Y'
35: AND oel.flow_status_code = 'AWAITING_RETURN'
36: AND msi.organization_id = oe_sys_parameters.VALUE('MASTER_ORGANIZATION_ID', oel.org_id)
37: AND msi.inventory_item_id = oel.inventory_item_id;
38:
39: -- specs for package level procedures
40: -- helpers for derive_rma_line

Line 1077: AND msi.organization_id = oe_sys_parameters.VALUE('MASTER_ORGANIZATION_ID', oel.org_id)

1073: AND oel.line_type_id = olt.transaction_type_id
1074: AND olt.transaction_type_code = 'LINE'
1075: AND olt.transaction_type_id = t.transaction_type_id
1076: AND t.LANGUAGE = USERENV('LANG')
1077: AND msi.organization_id = oe_sys_parameters.VALUE('MASTER_ORGANIZATION_ID', oel.org_id)
1078: AND msi.inventory_item_id = oel.inventory_item_id
1079: AND ( oel.ordered_item_id = NVL(v_customer_item_id, oel.ordered_item_id)
1080: OR oel.ordered_item_id IS NULL)
1081: AND oel.booked_flag = 'Y'