89: PROGRAM_UPDATE_DATE Who Column NUMBER(15)
90: */
91:
92:
93: insert into oe_bis_cust_sat_t (
94: ORGANIZATION_ID,
95: INVENTORY_ITEM_ID,
96: CUSTOMER_ID,
97: TRANSACTION_DATE,
148:
149:
150: /* FOR RETURNS */
151:
152: insert into oe_bis_cust_sat_t (
153: ORGANIZATION_ID,
154: INVENTORY_ITEM_ID,
155: CUSTOMER_ID,
156: TRANSACTION_DATE,
256:
257:
258: if app_col_name = ' ' then
259:
260: sql_stmt := 'insert into oe_bis_cust_sat_t2 ( SET_OF_BOOKS_ID,
261: SET_OF_BOOKS_NAME,
262: LEGAL_ENTITY_ID,
263: LEGAL_ENTITY_NAME,
264: OPERATING_UNIT_ID,
321: gl_periods year,
322: gl_periods quarter,
323: gl_periods month,
324: gl_sets_of_books gsob,
325: oe_bis_cust_sat_t obcs,
326: org_organization_definitions ood,
327: ra_customers rc,
328: hr_all_organization_units haou,
329: hr_locations_v hl,
367: trunc(obcs.transaction_date) between trunc(quarter.start_date) and trunc(quarter.end_date) and
368: trunc(obcs.transaction_date) between trunc(month.start_date) and trunc(month.end_date) ' ;
369: else
370:
371: sql_stmt := 'insert into oe_bis_cust_sat_t2 ( SET_OF_BOOKS_ID,
372: SET_OF_BOOKS_NAME,
373: LEGAL_ENTITY_ID,
374: LEGAL_ENTITY_NAME,
375: OPERATING_UNIT_ID,
434: gl_periods year,
435: gl_periods quarter,
436: gl_periods month,
437: gl_sets_of_books gsob,
438: oe_bis_cust_sat_t obcs,
439: org_organization_definitions ood,
440: ra_customers rc,
441: hr_all_organization_units haou,
442: hr_locations_v hl,